Exam 77-427 Microsoft Excel 2013 Expert 4. Create Advanced Charts and Tables 4.2 Create and Manage PivotTables: Manage Relationships (Diagram View)

PowerPivot: Diagram View 3. Try it: Display the Diagram View Go to Home ->View->Diagram View.   The Data Diagram has three Tables: tblProducts (a Table linked to Access). Table_tblSpecialty (a Table imported into Excel). Table_tblType (a Table imported into Excel).   What Do You See? The Tables are Joined by matching Fields. The Joins are represented by a line from one Table to another. If you click on a Join, the matching Fields will be outlined.   What Else Do You See? These Joins have an arrow. The arrow means that this is a One-to-Many Relationship. There are many different Specialties in Table_tblSpecialty. Each Item in tblProducts has only one Specialty.   Keep going... Home ->View->Diagram View